package com.nondo.dean.product.mapper;

import com.nondo.dean.product.domain.Product;
import com.nondo.dean.product.domain.ProductExample;
import com.nondo.dean.product.domain.ProductWithBLOBs;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.DeleteProvider;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.UpdateProvider;
import org.apache.ibatis.session.RowBounds;
import org.apache.ibatis.type.JdbcType;

public interface ProductMapper {
    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @SelectProvider(type=ProductSqlProvider.class, method="countByExample")
    long countByExample(ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @DeleteProvider(type=ProductSqlProvider.class, method="deleteByExample")
    int deleteByExample(ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @Delete({
        "delete from product",
        "where id = #{id,jdbcType=INTEGER}"
    })
    int deleteByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @Insert({
        "insert into product (id, code, ",
        "name, type_code, ",
        "unit, material_flag, ",
        "software_flag, create_period, ",
        "order_flag, status, ",
        "price_grade, cost_price, ",
        "sale_price, channel_20, ",
        "channel_40, business_code, ",
        "main_image, shelf_status, ",
        "brand_id, stock, ",
        "sale_num, guide_price, ",
        "grade_id, type_id, ",
        "create_by, create_date, ",
        "update_by, update_date, ",
        "remarks, del_flag, category_id, ",
        "in_the_inventory, reference_inventory, ",
        "series_id, inventory_type, ",
        "recommend, descrption, ",
        "is_special, detail_info, ",
        "properties, specifications)",
        "values (#{id,jdbcType=INTEGER}, #{code,jdbcType=VARCHAR}, ",
        "#{name,jdbcType=VARCHAR}, #{typeCode,jdbcType=VARCHAR}, ",
        "#{unit,jdbcType=VARCHAR}, #{materialFlag,jdbcType=VARCHAR}, ",
        "#{softwareFlag,jdbcType=VARCHAR}, #{createPeriod,jdbcType=VARCHAR}, ",
        "#{orderFlag,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, ",
        "#{priceGrade,jdbcType=INTEGER}, #{costPrice,jdbcType=DECIMAL}, ",
        "#{salePrice,jdbcType=DECIMAL}, #{channel20,jdbcType=VARCHAR}, ",
        "#{channel40,jdbcType=VARCHAR}, #{businessCode,jdbcType=VARCHAR}, ",
        "#{mainImage,jdbcType=VARCHAR}, #{shelfStatus,jdbcType=INTEGER}, ",
        "#{brandId,jdbcType=INTEGER}, #{stock,jdbcType=INTEGER}, ",
        "#{saleNum,jdbcType=INTEGER}, #{guidePrice,jdbcType=DECIMAL}, ",
        "#{gradeId,jdbcType=INTEGER}, #{typeId,jdbcType=INTEGER}, ",
        "#{createBy,jdbcType=BIGINT}, #{createDate,jdbcType=TIMESTAMP}, ",
        "#{updateBy,jdbcType=BIGINT}, #{updateDate,jdbcType=TIMESTAMP}, ",
        "#{remarks,jdbcType=VARCHAR}, #{delFlag,jdbcType=CHAR}, #{categoryId,jdbcType=INTEGER}, ",
        "#{inTheInventory,jdbcType=INTEGER}, #{referenceInventory,jdbcType=INTEGER}, ",
        "#{seriesId,jdbcType=INTEGER}, #{inventoryType,jdbcType=VARCHAR}, ",
        "#{recommend,jdbcType=INTEGER}, #{descrption,jdbcType=VARCHAR}, ",
        "#{isSpecial,jdbcType=INTEGER}, #{detailInfo,jdbcType=LONGVARCHAR}, ",
        "#{properties,jdbcType=LONGVARCHAR}, #{specifications,jdbcType=LONGVARCHAR})"
    })
    int insert(ProductWithBLOBs record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @InsertProvider(type=ProductSqlProvider.class, method="insertSelective")
    int insertSelective(ProductWithBLOBs record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @SelectProvider(type=ProductSqlProvider.class, method="selectByExampleWithBLOBs")
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="code", property="code", jdbcType=JdbcType.VARCHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="type_code", property="typeCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="unit", property="unit", jdbcType=JdbcType.VARCHAR),
        @Result(column="material_flag", property="materialFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="software_flag", property="softwareFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_period", property="createPeriod", jdbcType=JdbcType.VARCHAR),
        @Result(column="order_flag", property="orderFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="status", property="status", jdbcType=JdbcType.INTEGER),
        @Result(column="price_grade", property="priceGrade", jdbcType=JdbcType.INTEGER),
        @Result(column="cost_price", property="costPrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="sale_price", property="salePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="channel_20", property="channel20", jdbcType=JdbcType.VARCHAR),
        @Result(column="channel_40", property="channel40", jdbcType=JdbcType.VARCHAR),
        @Result(column="business_code", property="businessCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="main_image", property="mainImage", jdbcType=JdbcType.VARCHAR),
        @Result(column="shelf_status", property="shelfStatus", jdbcType=JdbcType.INTEGER),
        @Result(column="brand_id", property="brandId", jdbcType=JdbcType.INTEGER),
        @Result(column="stock", property="stock", jdbcType=JdbcType.INTEGER),
        @Result(column="sale_num", property="saleNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guide_price", property="guidePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="grade_id", property="gradeId", jdbcType=JdbcType.INTEGER),
        @Result(column="type_id", property="typeId", jdbcType=JdbcType.INTEGER),
        @Result(column="create_by", property="createBy", jdbcType=JdbcType.BIGINT),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_by", property="updateBy", jdbcType=JdbcType.BIGINT),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="remarks", property="remarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="del_flag", property="delFlag", jdbcType=JdbcType.CHAR),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.INTEGER),
        @Result(column="in_the_inventory", property="inTheInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="reference_inventory", property="referenceInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="series_id", property="seriesId", jdbcType=JdbcType.INTEGER),
        @Result(column="inventory_type", property="inventoryType", jdbcType=JdbcType.VARCHAR),
        @Result(column="recommend", property="recommend", jdbcType=JdbcType.INTEGER),
        @Result(column="descrption", property="descrption", jdbcType=JdbcType.VARCHAR),
        @Result(column="is_special", property="isSpecial", jdbcType=JdbcType.INTEGER),
        @Result(column="detail_info", property="detailInfo", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="properties", property="properties", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="specifications", property="specifications", jdbcType=JdbcType.LONGVARCHAR)
    })
    List<ProductWithBLOBs> selectByExampleWithBLOBsWithRowbounds(ProductExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @SelectProvider(type=ProductSqlProvider.class, method="selectByExampleWithBLOBs")
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="code", property="code", jdbcType=JdbcType.VARCHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="type_code", property="typeCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="unit", property="unit", jdbcType=JdbcType.VARCHAR),
        @Result(column="material_flag", property="materialFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="software_flag", property="softwareFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_period", property="createPeriod", jdbcType=JdbcType.VARCHAR),
        @Result(column="order_flag", property="orderFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="status", property="status", jdbcType=JdbcType.INTEGER),
        @Result(column="price_grade", property="priceGrade", jdbcType=JdbcType.INTEGER),
        @Result(column="cost_price", property="costPrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="sale_price", property="salePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="channel_20", property="channel20", jdbcType=JdbcType.VARCHAR),
        @Result(column="channel_40", property="channel40", jdbcType=JdbcType.VARCHAR),
        @Result(column="business_code", property="businessCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="main_image", property="mainImage", jdbcType=JdbcType.VARCHAR),
        @Result(column="shelf_status", property="shelfStatus", jdbcType=JdbcType.INTEGER),
        @Result(column="brand_id", property="brandId", jdbcType=JdbcType.INTEGER),
        @Result(column="stock", property="stock", jdbcType=JdbcType.INTEGER),
        @Result(column="sale_num", property="saleNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guide_price", property="guidePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="grade_id", property="gradeId", jdbcType=JdbcType.INTEGER),
        @Result(column="type_id", property="typeId", jdbcType=JdbcType.INTEGER),
        @Result(column="create_by", property="createBy", jdbcType=JdbcType.BIGINT),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_by", property="updateBy", jdbcType=JdbcType.BIGINT),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="remarks", property="remarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="del_flag", property="delFlag", jdbcType=JdbcType.CHAR),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.INTEGER),
        @Result(column="in_the_inventory", property="inTheInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="reference_inventory", property="referenceInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="series_id", property="seriesId", jdbcType=JdbcType.INTEGER),
        @Result(column="inventory_type", property="inventoryType", jdbcType=JdbcType.VARCHAR),
        @Result(column="recommend", property="recommend", jdbcType=JdbcType.INTEGER),
        @Result(column="descrption", property="descrption", jdbcType=JdbcType.VARCHAR),
        @Result(column="is_special", property="isSpecial", jdbcType=JdbcType.INTEGER),
        @Result(column="detail_info", property="detailInfo", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="properties", property="properties", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="specifications", property="specifications", jdbcType=JdbcType.LONGVARCHAR)
    })
    List<ProductWithBLOBs> selectByExampleWithBLOBs(ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @SelectProvider(type=ProductSqlProvider.class, method="selectByExample")
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="code", property="code", jdbcType=JdbcType.VARCHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="type_code", property="typeCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="unit", property="unit", jdbcType=JdbcType.VARCHAR),
        @Result(column="material_flag", property="materialFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="software_flag", property="softwareFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_period", property="createPeriod", jdbcType=JdbcType.VARCHAR),
        @Result(column="order_flag", property="orderFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="status", property="status", jdbcType=JdbcType.INTEGER),
        @Result(column="price_grade", property="priceGrade", jdbcType=JdbcType.INTEGER),
        @Result(column="cost_price", property="costPrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="sale_price", property="salePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="channel_20", property="channel20", jdbcType=JdbcType.VARCHAR),
        @Result(column="channel_40", property="channel40", jdbcType=JdbcType.VARCHAR),
        @Result(column="business_code", property="businessCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="main_image", property="mainImage", jdbcType=JdbcType.VARCHAR),
        @Result(column="shelf_status", property="shelfStatus", jdbcType=JdbcType.INTEGER),
        @Result(column="brand_id", property="brandId", jdbcType=JdbcType.INTEGER),
        @Result(column="stock", property="stock", jdbcType=JdbcType.INTEGER),
        @Result(column="sale_num", property="saleNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guide_price", property="guidePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="grade_id", property="gradeId", jdbcType=JdbcType.INTEGER),
        @Result(column="type_id", property="typeId", jdbcType=JdbcType.INTEGER),
        @Result(column="create_by", property="createBy", jdbcType=JdbcType.BIGINT),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_by", property="updateBy", jdbcType=JdbcType.BIGINT),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="remarks", property="remarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="del_flag", property="delFlag", jdbcType=JdbcType.CHAR),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.INTEGER),
        @Result(column="in_the_inventory", property="inTheInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="reference_inventory", property="referenceInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="series_id", property="seriesId", jdbcType=JdbcType.INTEGER),
        @Result(column="inventory_type", property="inventoryType", jdbcType=JdbcType.VARCHAR),
        @Result(column="recommend", property="recommend", jdbcType=JdbcType.INTEGER),
        @Result(column="descrption", property="descrption", jdbcType=JdbcType.VARCHAR),
        @Result(column="is_special", property="isSpecial", jdbcType=JdbcType.INTEGER)
    })
    List<Product> selectByExampleWithRowbounds(ProductExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @SelectProvider(type=ProductSqlProvider.class, method="selectByExample")
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="code", property="code", jdbcType=JdbcType.VARCHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="type_code", property="typeCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="unit", property="unit", jdbcType=JdbcType.VARCHAR),
        @Result(column="material_flag", property="materialFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="software_flag", property="softwareFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_period", property="createPeriod", jdbcType=JdbcType.VARCHAR),
        @Result(column="order_flag", property="orderFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="status", property="status", jdbcType=JdbcType.INTEGER),
        @Result(column="price_grade", property="priceGrade", jdbcType=JdbcType.INTEGER),
        @Result(column="cost_price", property="costPrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="sale_price", property="salePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="channel_20", property="channel20", jdbcType=JdbcType.VARCHAR),
        @Result(column="channel_40", property="channel40", jdbcType=JdbcType.VARCHAR),
        @Result(column="business_code", property="businessCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="main_image", property="mainImage", jdbcType=JdbcType.VARCHAR),
        @Result(column="shelf_status", property="shelfStatus", jdbcType=JdbcType.INTEGER),
        @Result(column="brand_id", property="brandId", jdbcType=JdbcType.INTEGER),
        @Result(column="stock", property="stock", jdbcType=JdbcType.INTEGER),
        @Result(column="sale_num", property="saleNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guide_price", property="guidePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="grade_id", property="gradeId", jdbcType=JdbcType.INTEGER),
        @Result(column="type_id", property="typeId", jdbcType=JdbcType.INTEGER),
        @Result(column="create_by", property="createBy", jdbcType=JdbcType.BIGINT),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_by", property="updateBy", jdbcType=JdbcType.BIGINT),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="remarks", property="remarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="del_flag", property="delFlag", jdbcType=JdbcType.CHAR),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.INTEGER),
        @Result(column="in_the_inventory", property="inTheInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="reference_inventory", property="referenceInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="series_id", property="seriesId", jdbcType=JdbcType.INTEGER),
        @Result(column="inventory_type", property="inventoryType", jdbcType=JdbcType.VARCHAR),
        @Result(column="recommend", property="recommend", jdbcType=JdbcType.INTEGER),
        @Result(column="descrption", property="descrption", jdbcType=JdbcType.VARCHAR),
        @Result(column="is_special", property="isSpecial", jdbcType=JdbcType.INTEGER)
    })
    List<Product> selectByExample(ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @Select({
        "select",
        "id, code, name, type_code, unit, material_flag, software_flag, create_period, ",
        "order_flag, status, price_grade, cost_price, sale_price, channel_20, channel_40, ",
        "business_code, main_image, shelf_status, brand_id, stock, sale_num, guide_price, ",
        "grade_id, type_id, create_by, create_date, update_by, update_date, remarks, ",
        "del_flag, category_id, in_the_inventory, reference_inventory, series_id, inventory_type, ",
        "recommend, descrption, is_special, detail_info, properties, specifications",
        "from product",
        "where id = #{id,jdbcType=INTEGER}"
    })
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.INTEGER, id=true),
        @Result(column="code", property="code", jdbcType=JdbcType.VARCHAR),
        @Result(column="name", property="name", jdbcType=JdbcType.VARCHAR),
        @Result(column="type_code", property="typeCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="unit", property="unit", jdbcType=JdbcType.VARCHAR),
        @Result(column="material_flag", property="materialFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="software_flag", property="softwareFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_period", property="createPeriod", jdbcType=JdbcType.VARCHAR),
        @Result(column="order_flag", property="orderFlag", jdbcType=JdbcType.VARCHAR),
        @Result(column="status", property="status", jdbcType=JdbcType.INTEGER),
        @Result(column="price_grade", property="priceGrade", jdbcType=JdbcType.INTEGER),
        @Result(column="cost_price", property="costPrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="sale_price", property="salePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="channel_20", property="channel20", jdbcType=JdbcType.VARCHAR),
        @Result(column="channel_40", property="channel40", jdbcType=JdbcType.VARCHAR),
        @Result(column="business_code", property="businessCode", jdbcType=JdbcType.VARCHAR),
        @Result(column="main_image", property="mainImage", jdbcType=JdbcType.VARCHAR),
        @Result(column="shelf_status", property="shelfStatus", jdbcType=JdbcType.INTEGER),
        @Result(column="brand_id", property="brandId", jdbcType=JdbcType.INTEGER),
        @Result(column="stock", property="stock", jdbcType=JdbcType.INTEGER),
        @Result(column="sale_num", property="saleNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guide_price", property="guidePrice", jdbcType=JdbcType.DECIMAL),
        @Result(column="grade_id", property="gradeId", jdbcType=JdbcType.INTEGER),
        @Result(column="type_id", property="typeId", jdbcType=JdbcType.INTEGER),
        @Result(column="create_by", property="createBy", jdbcType=JdbcType.BIGINT),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_by", property="updateBy", jdbcType=JdbcType.BIGINT),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="remarks", property="remarks", jdbcType=JdbcType.VARCHAR),
        @Result(column="del_flag", property="delFlag", jdbcType=JdbcType.CHAR),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.INTEGER),
        @Result(column="in_the_inventory", property="inTheInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="reference_inventory", property="referenceInventory", jdbcType=JdbcType.INTEGER),
        @Result(column="series_id", property="seriesId", jdbcType=JdbcType.INTEGER),
        @Result(column="inventory_type", property="inventoryType", jdbcType=JdbcType.VARCHAR),
        @Result(column="recommend", property="recommend", jdbcType=JdbcType.INTEGER),
        @Result(column="descrption", property="descrption", jdbcType=JdbcType.VARCHAR),
        @Result(column="is_special", property="isSpecial", jdbcType=JdbcType.INTEGER),
        @Result(column="detail_info", property="detailInfo", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="properties", property="properties", jdbcType=JdbcType.LONGVARCHAR),
        @Result(column="specifications", property="specifications", jdbcType=JdbcType.LONGVARCHAR)
    })
    ProductWithBLOBs selectByPrimaryKey(Integer id);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @UpdateProvider(type=ProductSqlProvider.class, method="updateByExampleSelective")
    int updateByExampleSelective(@Param("record") ProductWithBLOBs record, @Param("example") ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @UpdateProvider(type=ProductSqlProvider.class, method="updateByExampleWithBLOBs")
    int updateByExampleWithBLOBs(@Param("record") ProductWithBLOBs record, @Param("example") ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @UpdateProvider(type=ProductSqlProvider.class, method="updateByExample")
    int updateByExample(@Param("record") Product record, @Param("example") ProductExample example);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @UpdateProvider(type=ProductSqlProvider.class, method="updateByPrimaryKeySelective")
    int updateByPrimaryKeySelective(ProductWithBLOBs record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @Update({
        "update product",
        "set code = #{code,jdbcType=VARCHAR},",
          "name = #{name,jdbcType=VARCHAR},",
          "type_code = #{typeCode,jdbcType=VARCHAR},",
          "unit = #{unit,jdbcType=VARCHAR},",
          "material_flag = #{materialFlag,jdbcType=VARCHAR},",
          "software_flag = #{softwareFlag,jdbcType=VARCHAR},",
          "create_period = #{createPeriod,jdbcType=VARCHAR},",
          "order_flag = #{orderFlag,jdbcType=VARCHAR},",
          "status = #{status,jdbcType=INTEGER},",
          "price_grade = #{priceGrade,jdbcType=INTEGER},",
          "cost_price = #{costPrice,jdbcType=DECIMAL},",
          "sale_price = #{salePrice,jdbcType=DECIMAL},",
          "channel_20 = #{channel20,jdbcType=VARCHAR},",
          "channel_40 = #{channel40,jdbcType=VARCHAR},",
          "business_code = #{businessCode,jdbcType=VARCHAR},",
          "main_image = #{mainImage,jdbcType=VARCHAR},",
          "shelf_status = #{shelfStatus,jdbcType=INTEGER},",
          "brand_id = #{brandId,jdbcType=INTEGER},",
          "stock = #{stock,jdbcType=INTEGER},",
          "sale_num = #{saleNum,jdbcType=INTEGER},",
          "guide_price = #{guidePrice,jdbcType=DECIMAL},",
          "grade_id = #{gradeId,jdbcType=INTEGER},",
          "type_id = #{typeId,jdbcType=INTEGER},",
          "create_by = #{createBy,jdbcType=BIGINT},",
          "create_date = #{createDate,jdbcType=TIMESTAMP},",
          "update_by = #{updateBy,jdbcType=BIGINT},",
          "update_date = #{updateDate,jdbcType=TIMESTAMP},",
          "remarks = #{remarks,jdbcType=VARCHAR},",
          "del_flag = #{delFlag,jdbcType=CHAR},",
          "category_id = #{categoryId,jdbcType=INTEGER},",
          "in_the_inventory = #{inTheInventory,jdbcType=INTEGER},",
          "reference_inventory = #{referenceInventory,jdbcType=INTEGER},",
          "series_id = #{seriesId,jdbcType=INTEGER},",
          "inventory_type = #{inventoryType,jdbcType=VARCHAR},",
          "recommend = #{recommend,jdbcType=INTEGER},",
          "descrption = #{descrption,jdbcType=VARCHAR},",
          "is_special = #{isSpecial,jdbcType=INTEGER},",
          "detail_info = #{detailInfo,jdbcType=LONGVARCHAR},",
          "properties = #{properties,jdbcType=LONGVARCHAR},",
          "specifications = #{specifications,jdbcType=LONGVARCHAR}",
        "where id = #{id,jdbcType=INTEGER}"
    })
    int updateByPrimaryKeyWithBLOBs(ProductWithBLOBs record);

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table product
     *
     * @mbg.generated Tue Jul 24 16:29:46 CST 2018
     */
    @Update({
        "update product",
        "set code = #{code,jdbcType=VARCHAR},",
          "name = #{name,jdbcType=VARCHAR},",
          "type_code = #{typeCode,jdbcType=VARCHAR},",
          "unit = #{unit,jdbcType=VARCHAR},",
          "material_flag = #{materialFlag,jdbcType=VARCHAR},",
          "software_flag = #{softwareFlag,jdbcType=VARCHAR},",
          "create_period = #{createPeriod,jdbcType=VARCHAR},",
          "order_flag = #{orderFlag,jdbcType=VARCHAR},",
          "status = #{status,jdbcType=INTEGER},",
          "price_grade = #{priceGrade,jdbcType=INTEGER},",
          "cost_price = #{costPrice,jdbcType=DECIMAL},",
          "sale_price = #{salePrice,jdbcType=DECIMAL},",
          "channel_20 = #{channel20,jdbcType=VARCHAR},",
          "channel_40 = #{channel40,jdbcType=VARCHAR},",
          "business_code = #{businessCode,jdbcType=VARCHAR},",
          "main_image = #{mainImage,jdbcType=VARCHAR},",
          "shelf_status = #{shelfStatus,jdbcType=INTEGER},",
          "brand_id = #{brandId,jdbcType=INTEGER},",
          "stock = #{stock,jdbcType=INTEGER},",
          "sale_num = #{saleNum,jdbcType=INTEGER},",
          "guide_price = #{guidePrice,jdbcType=DECIMAL},",
          "grade_id = #{gradeId,jdbcType=INTEGER},",
          "type_id = #{typeId,jdbcType=INTEGER},",
          "create_by = #{createBy,jdbcType=BIGINT},",
          "create_date = #{createDate,jdbcType=TIMESTAMP},",
          "update_by = #{updateBy,jdbcType=BIGINT},",
          "update_date = #{updateDate,jdbcType=TIMESTAMP},",
          "remarks = #{remarks,jdbcType=VARCHAR},",
          "del_flag = #{delFlag,jdbcType=CHAR},",
          "category_id = #{categoryId,jdbcType=INTEGER},",
          "in_the_inventory = #{inTheInventory,jdbcType=INTEGER},",
          "reference_inventory = #{referenceInventory,jdbcType=INTEGER},",
          "series_id = #{seriesId,jdbcType=INTEGER},",
          "inventory_type = #{inventoryType,jdbcType=VARCHAR},",
          "recommend = #{recommend,jdbcType=INTEGER},",
          "descrption = #{descrption,jdbcType=VARCHAR},",
          "is_special = #{isSpecial,jdbcType=INTEGER}",
        "where id = #{id,jdbcType=INTEGER}"
    })
    int updateByPrimaryKey(Product record);
}